package com.info.zhiduoduo.repository.mapper.system;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.info.zhiduoduo.repository.entity.system.AccountLinkLabel;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author tianyonghong
 * @create 2023/10/18
 */
public interface AccountLinkLabelMapper extends BaseMapper<AccountLinkLabel> {

    @Select("select * from zdd_account_link_label " +
            " where 1= 1" +
            " and if(ISNULL(#{type}) or #{type} = 0 , 1=1, type = #{type}) " +
            " and if(ISNULL(#{label}) or #{label} = '', 1=1, label = #{label}) " +
            " order by id desc")
    List<AccountLinkLabel> queryList(Integer type,String label);
}
